﻿CREATE PROCEDURE [dbo].[usp_get_accesspolicy_list]
	@pUserOrGroupNameCommaDelimitedList dbo.UserOrGroupList READONLY
AS

	SELECT ap.Id
		, ap.UserOrGroupName
		, ap.AccessPolicy
		, ap.LastModifiedOn
		, ap.LastModifiedBy
	FROM [dbo].[AccessPolicy] ap
	WHERE ap.UserOrGroupName IN (SELECT Name FROM @pUserOrGroupNameCommaDelimitedList)

RETURN 0